package com.example.demo.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TMaterielExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TMaterielExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("code <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("code >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("code <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("code not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("code in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("code not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("code between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("code not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andAladingCodeIsNull() {
            addCriterion("alading_code is null");
            return (Criteria) this;
        }

        public Criteria andAladingCodeIsNotNull() {
            addCriterion("alading_code is not null");
            return (Criteria) this;
        }

        public Criteria andAladingCodeEqualTo(String value) {
            addCriterion("alading_code =", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeNotEqualTo(String value) {
            addCriterion("alading_code <>", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeGreaterThan(String value) {
            addCriterion("alading_code >", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeGreaterThanOrEqualTo(String value) {
            addCriterion("alading_code >=", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeLessThan(String value) {
            addCriterion("alading_code <", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeLessThanOrEqualTo(String value) {
            addCriterion("alading_code <=", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeLike(String value) {
            addCriterion("alading_code like", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeNotLike(String value) {
            addCriterion("alading_code not like", value, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeIn(List<String> values) {
            addCriterion("alading_code in", values, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeNotIn(List<String> values) {
            addCriterion("alading_code not in", values, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeBetween(String value1, String value2) {
            addCriterion("alading_code between", value1, value2, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andAladingCodeNotBetween(String value1, String value2) {
            addCriterion("alading_code not between", value1, value2, "aladingCode");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusIsNull() {
            addCriterion("mall_putaway_status is null");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusIsNotNull() {
            addCriterion("mall_putaway_status is not null");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusEqualTo(Integer value) {
            addCriterion("mall_putaway_status =", value, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusNotEqualTo(Integer value) {
            addCriterion("mall_putaway_status <>", value, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusGreaterThan(Integer value) {
            addCriterion("mall_putaway_status >", value, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("mall_putaway_status >=", value, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusLessThan(Integer value) {
            addCriterion("mall_putaway_status <", value, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusLessThanOrEqualTo(Integer value) {
            addCriterion("mall_putaway_status <=", value, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusIn(List<Integer> values) {
            addCriterion("mall_putaway_status in", values, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusNotIn(List<Integer> values) {
            addCriterion("mall_putaway_status not in", values, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusBetween(Integer value1, Integer value2) {
            addCriterion("mall_putaway_status between", value1, value2, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andMallPutawayStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("mall_putaway_status not between", value1, value2, "mallPutawayStatus");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceIsNull() {
            addCriterion("suggested_retail_price is null");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceIsNotNull() {
            addCriterion("suggested_retail_price is not null");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceEqualTo(Integer value) {
            addCriterion("suggested_retail_price =", value, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceNotEqualTo(Integer value) {
            addCriterion("suggested_retail_price <>", value, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceGreaterThan(Integer value) {
            addCriterion("suggested_retail_price >", value, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("suggested_retail_price >=", value, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceLessThan(Integer value) {
            addCriterion("suggested_retail_price <", value, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceLessThanOrEqualTo(Integer value) {
            addCriterion("suggested_retail_price <=", value, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceIn(List<Integer> values) {
            addCriterion("suggested_retail_price in", values, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceNotIn(List<Integer> values) {
            addCriterion("suggested_retail_price not in", values, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceBetween(Integer value1, Integer value2) {
            addCriterion("suggested_retail_price between", value1, value2, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andSuggestedRetailPriceNotBetween(Integer value1, Integer value2) {
            addCriterion("suggested_retail_price not between", value1, value2, "suggestedRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceIsNull() {
            addCriterion("vehicle_retail_price is null");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceIsNotNull() {
            addCriterion("vehicle_retail_price is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceEqualTo(Integer value) {
            addCriterion("vehicle_retail_price =", value, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceNotEqualTo(Integer value) {
            addCriterion("vehicle_retail_price <>", value, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceGreaterThan(Integer value) {
            addCriterion("vehicle_retail_price >", value, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("vehicle_retail_price >=", value, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceLessThan(Integer value) {
            addCriterion("vehicle_retail_price <", value, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceLessThanOrEqualTo(Integer value) {
            addCriterion("vehicle_retail_price <=", value, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceIn(List<Integer> values) {
            addCriterion("vehicle_retail_price in", values, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceNotIn(List<Integer> values) {
            addCriterion("vehicle_retail_price not in", values, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceBetween(Integer value1, Integer value2) {
            addCriterion("vehicle_retail_price between", value1, value2, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andVehicleRetailPriceNotBetween(Integer value1, Integer value2) {
            addCriterion("vehicle_retail_price not between", value1, value2, "vehicleRetailPrice");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitIsNull() {
            addCriterion("warranty_time_limit is null");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitIsNotNull() {
            addCriterion("warranty_time_limit is not null");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitEqualTo(Integer value) {
            addCriterion("warranty_time_limit =", value, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitNotEqualTo(Integer value) {
            addCriterion("warranty_time_limit <>", value, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitGreaterThan(Integer value) {
            addCriterion("warranty_time_limit >", value, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitGreaterThanOrEqualTo(Integer value) {
            addCriterion("warranty_time_limit >=", value, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitLessThan(Integer value) {
            addCriterion("warranty_time_limit <", value, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitLessThanOrEqualTo(Integer value) {
            addCriterion("warranty_time_limit <=", value, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitIn(List<Integer> values) {
            addCriterion("warranty_time_limit in", values, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitNotIn(List<Integer> values) {
            addCriterion("warranty_time_limit not in", values, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitBetween(Integer value1, Integer value2) {
            addCriterion("warranty_time_limit between", value1, value2, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andWarrantyTimeLimitNotBetween(Integer value1, Integer value2) {
            addCriterion("warranty_time_limit not between", value1, value2, "warrantyTimeLimit");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdIsNull() {
            addCriterion("vehicle_series_id is null");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdIsNotNull() {
            addCriterion("vehicle_series_id is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdEqualTo(Long value) {
            addCriterion("vehicle_series_id =", value, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdNotEqualTo(Long value) {
            addCriterion("vehicle_series_id <>", value, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdGreaterThan(Long value) {
            addCriterion("vehicle_series_id >", value, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vehicle_series_id >=", value, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdLessThan(Long value) {
            addCriterion("vehicle_series_id <", value, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdLessThanOrEqualTo(Long value) {
            addCriterion("vehicle_series_id <=", value, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdIn(List<Long> values) {
            addCriterion("vehicle_series_id in", values, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdNotIn(List<Long> values) {
            addCriterion("vehicle_series_id not in", values, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdBetween(Long value1, Long value2) {
            addCriterion("vehicle_series_id between", value1, value2, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesIdNotBetween(Long value1, Long value2) {
            addCriterion("vehicle_series_id not between", value1, value2, "vehicleSeriesId");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeIsNull() {
            addCriterion("vehicle_series_code is null");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeIsNotNull() {
            addCriterion("vehicle_series_code is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeEqualTo(String value) {
            addCriterion("vehicle_series_code =", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeNotEqualTo(String value) {
            addCriterion("vehicle_series_code <>", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeGreaterThan(String value) {
            addCriterion("vehicle_series_code >", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_series_code >=", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeLessThan(String value) {
            addCriterion("vehicle_series_code <", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeLessThanOrEqualTo(String value) {
            addCriterion("vehicle_series_code <=", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeLike(String value) {
            addCriterion("vehicle_series_code like", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeNotLike(String value) {
            addCriterion("vehicle_series_code not like", value, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeIn(List<String> values) {
            addCriterion("vehicle_series_code in", values, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeNotIn(List<String> values) {
            addCriterion("vehicle_series_code not in", values, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeBetween(String value1, String value2) {
            addCriterion("vehicle_series_code between", value1, value2, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesCodeNotBetween(String value1, String value2) {
            addCriterion("vehicle_series_code not between", value1, value2, "vehicleSeriesCode");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameIsNull() {
            addCriterion("vehicle_series_name is null");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameIsNotNull() {
            addCriterion("vehicle_series_name is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameEqualTo(String value) {
            addCriterion("vehicle_series_name =", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameNotEqualTo(String value) {
            addCriterion("vehicle_series_name <>", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameGreaterThan(String value) {
            addCriterion("vehicle_series_name >", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_series_name >=", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameLessThan(String value) {
            addCriterion("vehicle_series_name <", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameLessThanOrEqualTo(String value) {
            addCriterion("vehicle_series_name <=", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameLike(String value) {
            addCriterion("vehicle_series_name like", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameNotLike(String value) {
            addCriterion("vehicle_series_name not like", value, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameIn(List<String> values) {
            addCriterion("vehicle_series_name in", values, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameNotIn(List<String> values) {
            addCriterion("vehicle_series_name not in", values, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameBetween(String value1, String value2) {
            addCriterion("vehicle_series_name between", value1, value2, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleSeriesNameNotBetween(String value1, String value2) {
            addCriterion("vehicle_series_name not between", value1, value2, "vehicleSeriesName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdIsNull() {
            addCriterion("vehicle_type_id is null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdIsNotNull() {
            addCriterion("vehicle_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdEqualTo(Long value) {
            addCriterion("vehicle_type_id =", value, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdNotEqualTo(Long value) {
            addCriterion("vehicle_type_id <>", value, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdGreaterThan(Long value) {
            addCriterion("vehicle_type_id >", value, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vehicle_type_id >=", value, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdLessThan(Long value) {
            addCriterion("vehicle_type_id <", value, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdLessThanOrEqualTo(Long value) {
            addCriterion("vehicle_type_id <=", value, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdIn(List<Long> values) {
            addCriterion("vehicle_type_id in", values, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdNotIn(List<Long> values) {
            addCriterion("vehicle_type_id not in", values, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdBetween(Long value1, Long value2) {
            addCriterion("vehicle_type_id between", value1, value2, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeIdNotBetween(Long value1, Long value2) {
            addCriterion("vehicle_type_id not between", value1, value2, "vehicleTypeId");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeIsNull() {
            addCriterion("vehicle_type_code is null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeIsNotNull() {
            addCriterion("vehicle_type_code is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeEqualTo(String value) {
            addCriterion("vehicle_type_code =", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeNotEqualTo(String value) {
            addCriterion("vehicle_type_code <>", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeGreaterThan(String value) {
            addCriterion("vehicle_type_code >", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_type_code >=", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeLessThan(String value) {
            addCriterion("vehicle_type_code <", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeLessThanOrEqualTo(String value) {
            addCriterion("vehicle_type_code <=", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeLike(String value) {
            addCriterion("vehicle_type_code like", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeNotLike(String value) {
            addCriterion("vehicle_type_code not like", value, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeIn(List<String> values) {
            addCriterion("vehicle_type_code in", values, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeNotIn(List<String> values) {
            addCriterion("vehicle_type_code not in", values, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeBetween(String value1, String value2) {
            addCriterion("vehicle_type_code between", value1, value2, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeCodeNotBetween(String value1, String value2) {
            addCriterion("vehicle_type_code not between", value1, value2, "vehicleTypeCode");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameIsNull() {
            addCriterion("vehicle_type_name is null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameIsNotNull() {
            addCriterion("vehicle_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameEqualTo(String value) {
            addCriterion("vehicle_type_name =", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameNotEqualTo(String value) {
            addCriterion("vehicle_type_name <>", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameGreaterThan(String value) {
            addCriterion("vehicle_type_name >", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_type_name >=", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameLessThan(String value) {
            addCriterion("vehicle_type_name <", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameLessThanOrEqualTo(String value) {
            addCriterion("vehicle_type_name <=", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameLike(String value) {
            addCriterion("vehicle_type_name like", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameNotLike(String value) {
            addCriterion("vehicle_type_name not like", value, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameIn(List<String> values) {
            addCriterion("vehicle_type_name in", values, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameNotIn(List<String> values) {
            addCriterion("vehicle_type_name not in", values, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameBetween(String value1, String value2) {
            addCriterion("vehicle_type_name between", value1, value2, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleTypeNameNotBetween(String value1, String value2) {
            addCriterion("vehicle_type_name not between", value1, value2, "vehicleTypeName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdIsNull() {
            addCriterion("vehicle_color_outer_id is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdIsNotNull() {
            addCriterion("vehicle_color_outer_id is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdEqualTo(Long value) {
            addCriterion("vehicle_color_outer_id =", value, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdNotEqualTo(Long value) {
            addCriterion("vehicle_color_outer_id <>", value, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdGreaterThan(Long value) {
            addCriterion("vehicle_color_outer_id >", value, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vehicle_color_outer_id >=", value, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdLessThan(Long value) {
            addCriterion("vehicle_color_outer_id <", value, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdLessThanOrEqualTo(Long value) {
            addCriterion("vehicle_color_outer_id <=", value, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdIn(List<Long> values) {
            addCriterion("vehicle_color_outer_id in", values, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdNotIn(List<Long> values) {
            addCriterion("vehicle_color_outer_id not in", values, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdBetween(Long value1, Long value2) {
            addCriterion("vehicle_color_outer_id between", value1, value2, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterIdNotBetween(Long value1, Long value2) {
            addCriterion("vehicle_color_outer_id not between", value1, value2, "vehicleColorOuterId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeIsNull() {
            addCriterion("vehicle_color_outer_code is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeIsNotNull() {
            addCriterion("vehicle_color_outer_code is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeEqualTo(String value) {
            addCriterion("vehicle_color_outer_code =", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeNotEqualTo(String value) {
            addCriterion("vehicle_color_outer_code <>", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeGreaterThan(String value) {
            addCriterion("vehicle_color_outer_code >", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_color_outer_code >=", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeLessThan(String value) {
            addCriterion("vehicle_color_outer_code <", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeLessThanOrEqualTo(String value) {
            addCriterion("vehicle_color_outer_code <=", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeLike(String value) {
            addCriterion("vehicle_color_outer_code like", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeNotLike(String value) {
            addCriterion("vehicle_color_outer_code not like", value, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeIn(List<String> values) {
            addCriterion("vehicle_color_outer_code in", values, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeNotIn(List<String> values) {
            addCriterion("vehicle_color_outer_code not in", values, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeBetween(String value1, String value2) {
            addCriterion("vehicle_color_outer_code between", value1, value2, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterCodeNotBetween(String value1, String value2) {
            addCriterion("vehicle_color_outer_code not between", value1, value2, "vehicleColorOuterCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameIsNull() {
            addCriterion("vehicle_color_outer_name is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameIsNotNull() {
            addCriterion("vehicle_color_outer_name is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameEqualTo(String value) {
            addCriterion("vehicle_color_outer_name =", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameNotEqualTo(String value) {
            addCriterion("vehicle_color_outer_name <>", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameGreaterThan(String value) {
            addCriterion("vehicle_color_outer_name >", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_color_outer_name >=", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameLessThan(String value) {
            addCriterion("vehicle_color_outer_name <", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameLessThanOrEqualTo(String value) {
            addCriterion("vehicle_color_outer_name <=", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameLike(String value) {
            addCriterion("vehicle_color_outer_name like", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameNotLike(String value) {
            addCriterion("vehicle_color_outer_name not like", value, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameIn(List<String> values) {
            addCriterion("vehicle_color_outer_name in", values, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameNotIn(List<String> values) {
            addCriterion("vehicle_color_outer_name not in", values, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameBetween(String value1, String value2) {
            addCriterion("vehicle_color_outer_name between", value1, value2, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorOuterNameNotBetween(String value1, String value2) {
            addCriterion("vehicle_color_outer_name not between", value1, value2, "vehicleColorOuterName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdIsNull() {
            addCriterion("vehicle_color_inner_id is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdIsNotNull() {
            addCriterion("vehicle_color_inner_id is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdEqualTo(Long value) {
            addCriterion("vehicle_color_inner_id =", value, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdNotEqualTo(Long value) {
            addCriterion("vehicle_color_inner_id <>", value, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdGreaterThan(Long value) {
            addCriterion("vehicle_color_inner_id >", value, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vehicle_color_inner_id >=", value, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdLessThan(Long value) {
            addCriterion("vehicle_color_inner_id <", value, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdLessThanOrEqualTo(Long value) {
            addCriterion("vehicle_color_inner_id <=", value, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdIn(List<Long> values) {
            addCriterion("vehicle_color_inner_id in", values, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdNotIn(List<Long> values) {
            addCriterion("vehicle_color_inner_id not in", values, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdBetween(Long value1, Long value2) {
            addCriterion("vehicle_color_inner_id between", value1, value2, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerIdNotBetween(Long value1, Long value2) {
            addCriterion("vehicle_color_inner_id not between", value1, value2, "vehicleColorInnerId");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeIsNull() {
            addCriterion("vehicle_color_inner_code is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeIsNotNull() {
            addCriterion("vehicle_color_inner_code is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeEqualTo(String value) {
            addCriterion("vehicle_color_inner_code =", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeNotEqualTo(String value) {
            addCriterion("vehicle_color_inner_code <>", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeGreaterThan(String value) {
            addCriterion("vehicle_color_inner_code >", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_color_inner_code >=", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeLessThan(String value) {
            addCriterion("vehicle_color_inner_code <", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeLessThanOrEqualTo(String value) {
            addCriterion("vehicle_color_inner_code <=", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeLike(String value) {
            addCriterion("vehicle_color_inner_code like", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeNotLike(String value) {
            addCriterion("vehicle_color_inner_code not like", value, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeIn(List<String> values) {
            addCriterion("vehicle_color_inner_code in", values, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeNotIn(List<String> values) {
            addCriterion("vehicle_color_inner_code not in", values, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeBetween(String value1, String value2) {
            addCriterion("vehicle_color_inner_code between", value1, value2, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerCodeNotBetween(String value1, String value2) {
            addCriterion("vehicle_color_inner_code not between", value1, value2, "vehicleColorInnerCode");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameIsNull() {
            addCriterion("vehicle_color_inner_name is null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameIsNotNull() {
            addCriterion("vehicle_color_inner_name is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameEqualTo(String value) {
            addCriterion("vehicle_color_inner_name =", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameNotEqualTo(String value) {
            addCriterion("vehicle_color_inner_name <>", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameGreaterThan(String value) {
            addCriterion("vehicle_color_inner_name >", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_color_inner_name >=", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameLessThan(String value) {
            addCriterion("vehicle_color_inner_name <", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameLessThanOrEqualTo(String value) {
            addCriterion("vehicle_color_inner_name <=", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameLike(String value) {
            addCriterion("vehicle_color_inner_name like", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameNotLike(String value) {
            addCriterion("vehicle_color_inner_name not like", value, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameIn(List<String> values) {
            addCriterion("vehicle_color_inner_name in", values, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameNotIn(List<String> values) {
            addCriterion("vehicle_color_inner_name not in", values, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameBetween(String value1, String value2) {
            addCriterion("vehicle_color_inner_name between", value1, value2, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehicleColorInnerNameNotBetween(String value1, String value2) {
            addCriterion("vehicle_color_inner_name not between", value1, value2, "vehicleColorInnerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdIsNull() {
            addCriterion("vehicle_power_id is null");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdIsNotNull() {
            addCriterion("vehicle_power_id is not null");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdEqualTo(Long value) {
            addCriterion("vehicle_power_id =", value, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdNotEqualTo(Long value) {
            addCriterion("vehicle_power_id <>", value, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdGreaterThan(Long value) {
            addCriterion("vehicle_power_id >", value, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vehicle_power_id >=", value, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdLessThan(Long value) {
            addCriterion("vehicle_power_id <", value, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdLessThanOrEqualTo(Long value) {
            addCriterion("vehicle_power_id <=", value, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdIn(List<Long> values) {
            addCriterion("vehicle_power_id in", values, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdNotIn(List<Long> values) {
            addCriterion("vehicle_power_id not in", values, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdBetween(Long value1, Long value2) {
            addCriterion("vehicle_power_id between", value1, value2, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerIdNotBetween(Long value1, Long value2) {
            addCriterion("vehicle_power_id not between", value1, value2, "vehiclePowerId");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeIsNull() {
            addCriterion("vehicle_power_code is null");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeIsNotNull() {
            addCriterion("vehicle_power_code is not null");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeEqualTo(String value) {
            addCriterion("vehicle_power_code =", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeNotEqualTo(String value) {
            addCriterion("vehicle_power_code <>", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeGreaterThan(String value) {
            addCriterion("vehicle_power_code >", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_power_code >=", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeLessThan(String value) {
            addCriterion("vehicle_power_code <", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeLessThanOrEqualTo(String value) {
            addCriterion("vehicle_power_code <=", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeLike(String value) {
            addCriterion("vehicle_power_code like", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeNotLike(String value) {
            addCriterion("vehicle_power_code not like", value, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeIn(List<String> values) {
            addCriterion("vehicle_power_code in", values, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeNotIn(List<String> values) {
            addCriterion("vehicle_power_code not in", values, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeBetween(String value1, String value2) {
            addCriterion("vehicle_power_code between", value1, value2, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerCodeNotBetween(String value1, String value2) {
            addCriterion("vehicle_power_code not between", value1, value2, "vehiclePowerCode");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameIsNull() {
            addCriterion("vehicle_power_name is null");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameIsNotNull() {
            addCriterion("vehicle_power_name is not null");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameEqualTo(String value) {
            addCriterion("vehicle_power_name =", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameNotEqualTo(String value) {
            addCriterion("vehicle_power_name <>", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameGreaterThan(String value) {
            addCriterion("vehicle_power_name >", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_power_name >=", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameLessThan(String value) {
            addCriterion("vehicle_power_name <", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameLessThanOrEqualTo(String value) {
            addCriterion("vehicle_power_name <=", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameLike(String value) {
            addCriterion("vehicle_power_name like", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameNotLike(String value) {
            addCriterion("vehicle_power_name not like", value, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameIn(List<String> values) {
            addCriterion("vehicle_power_name in", values, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameNotIn(List<String> values) {
            addCriterion("vehicle_power_name not in", values, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameBetween(String value1, String value2) {
            addCriterion("vehicle_power_name between", value1, value2, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehiclePowerNameNotBetween(String value1, String value2) {
            addCriterion("vehicle_power_name not between", value1, value2, "vehiclePowerName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdIsNull() {
            addCriterion("vehicle_config_group_id is null");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdIsNotNull() {
            addCriterion("vehicle_config_group_id is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdEqualTo(Long value) {
            addCriterion("vehicle_config_group_id =", value, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdNotEqualTo(Long value) {
            addCriterion("vehicle_config_group_id <>", value, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdGreaterThan(Long value) {
            addCriterion("vehicle_config_group_id >", value, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdGreaterThanOrEqualTo(Long value) {
            addCriterion("vehicle_config_group_id >=", value, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdLessThan(Long value) {
            addCriterion("vehicle_config_group_id <", value, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdLessThanOrEqualTo(Long value) {
            addCriterion("vehicle_config_group_id <=", value, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdIn(List<Long> values) {
            addCriterion("vehicle_config_group_id in", values, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdNotIn(List<Long> values) {
            addCriterion("vehicle_config_group_id not in", values, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdBetween(Long value1, Long value2) {
            addCriterion("vehicle_config_group_id between", value1, value2, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupIdNotBetween(Long value1, Long value2) {
            addCriterion("vehicle_config_group_id not between", value1, value2, "vehicleConfigGroupId");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeIsNull() {
            addCriterion("vehicle_config_group_code is null");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeIsNotNull() {
            addCriterion("vehicle_config_group_code is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeEqualTo(String value) {
            addCriterion("vehicle_config_group_code =", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeNotEqualTo(String value) {
            addCriterion("vehicle_config_group_code <>", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeGreaterThan(String value) {
            addCriterion("vehicle_config_group_code >", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_config_group_code >=", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeLessThan(String value) {
            addCriterion("vehicle_config_group_code <", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeLessThanOrEqualTo(String value) {
            addCriterion("vehicle_config_group_code <=", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeLike(String value) {
            addCriterion("vehicle_config_group_code like", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeNotLike(String value) {
            addCriterion("vehicle_config_group_code not like", value, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeIn(List<String> values) {
            addCriterion("vehicle_config_group_code in", values, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeNotIn(List<String> values) {
            addCriterion("vehicle_config_group_code not in", values, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeBetween(String value1, String value2) {
            addCriterion("vehicle_config_group_code between", value1, value2, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupCodeNotBetween(String value1, String value2) {
            addCriterion("vehicle_config_group_code not between", value1, value2, "vehicleConfigGroupCode");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameIsNull() {
            addCriterion("vehicle_config_group_name is null");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameIsNotNull() {
            addCriterion("vehicle_config_group_name is not null");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameEqualTo(String value) {
            addCriterion("vehicle_config_group_name =", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameNotEqualTo(String value) {
            addCriterion("vehicle_config_group_name <>", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameGreaterThan(String value) {
            addCriterion("vehicle_config_group_name >", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameGreaterThanOrEqualTo(String value) {
            addCriterion("vehicle_config_group_name >=", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameLessThan(String value) {
            addCriterion("vehicle_config_group_name <", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameLessThanOrEqualTo(String value) {
            addCriterion("vehicle_config_group_name <=", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameLike(String value) {
            addCriterion("vehicle_config_group_name like", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameNotLike(String value) {
            addCriterion("vehicle_config_group_name not like", value, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameIn(List<String> values) {
            addCriterion("vehicle_config_group_name in", values, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameNotIn(List<String> values) {
            addCriterion("vehicle_config_group_name not in", values, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameBetween(String value1, String value2) {
            addCriterion("vehicle_config_group_name between", value1, value2, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andVehicleConfigGroupNameNotBetween(String value1, String value2) {
            addCriterion("vehicle_config_group_name not between", value1, value2, "vehicleConfigGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdIsNull() {
            addCriterion("materiel_group_id is null");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdIsNotNull() {
            addCriterion("materiel_group_id is not null");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdEqualTo(Long value) {
            addCriterion("materiel_group_id =", value, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdNotEqualTo(Long value) {
            addCriterion("materiel_group_id <>", value, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdGreaterThan(Long value) {
            addCriterion("materiel_group_id >", value, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdGreaterThanOrEqualTo(Long value) {
            addCriterion("materiel_group_id >=", value, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdLessThan(Long value) {
            addCriterion("materiel_group_id <", value, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdLessThanOrEqualTo(Long value) {
            addCriterion("materiel_group_id <=", value, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdIn(List<Long> values) {
            addCriterion("materiel_group_id in", values, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdNotIn(List<Long> values) {
            addCriterion("materiel_group_id not in", values, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdBetween(Long value1, Long value2) {
            addCriterion("materiel_group_id between", value1, value2, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupIdNotBetween(Long value1, Long value2) {
            addCriterion("materiel_group_id not between", value1, value2, "materielGroupId");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeIsNull() {
            addCriterion("materiel_group_code is null");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeIsNotNull() {
            addCriterion("materiel_group_code is not null");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeEqualTo(String value) {
            addCriterion("materiel_group_code =", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeNotEqualTo(String value) {
            addCriterion("materiel_group_code <>", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeGreaterThan(String value) {
            addCriterion("materiel_group_code >", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeGreaterThanOrEqualTo(String value) {
            addCriterion("materiel_group_code >=", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeLessThan(String value) {
            addCriterion("materiel_group_code <", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeLessThanOrEqualTo(String value) {
            addCriterion("materiel_group_code <=", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeLike(String value) {
            addCriterion("materiel_group_code like", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeNotLike(String value) {
            addCriterion("materiel_group_code not like", value, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeIn(List<String> values) {
            addCriterion("materiel_group_code in", values, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeNotIn(List<String> values) {
            addCriterion("materiel_group_code not in", values, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeBetween(String value1, String value2) {
            addCriterion("materiel_group_code between", value1, value2, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupCodeNotBetween(String value1, String value2) {
            addCriterion("materiel_group_code not between", value1, value2, "materielGroupCode");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameIsNull() {
            addCriterion("materiel_group_name is null");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameIsNotNull() {
            addCriterion("materiel_group_name is not null");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameEqualTo(String value) {
            addCriterion("materiel_group_name =", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameNotEqualTo(String value) {
            addCriterion("materiel_group_name <>", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameGreaterThan(String value) {
            addCriterion("materiel_group_name >", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameGreaterThanOrEqualTo(String value) {
            addCriterion("materiel_group_name >=", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameLessThan(String value) {
            addCriterion("materiel_group_name <", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameLessThanOrEqualTo(String value) {
            addCriterion("materiel_group_name <=", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameLike(String value) {
            addCriterion("materiel_group_name like", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameNotLike(String value) {
            addCriterion("materiel_group_name not like", value, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameIn(List<String> values) {
            addCriterion("materiel_group_name in", values, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameNotIn(List<String> values) {
            addCriterion("materiel_group_name not in", values, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameBetween(String value1, String value2) {
            addCriterion("materiel_group_name between", value1, value2, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielGroupNameNotBetween(String value1, String value2) {
            addCriterion("materiel_group_name not between", value1, value2, "materielGroupName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdIsNull() {
            addCriterion("materiel_unit_id is null");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdIsNotNull() {
            addCriterion("materiel_unit_id is not null");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdEqualTo(Long value) {
            addCriterion("materiel_unit_id =", value, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdNotEqualTo(Long value) {
            addCriterion("materiel_unit_id <>", value, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdGreaterThan(Long value) {
            addCriterion("materiel_unit_id >", value, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdGreaterThanOrEqualTo(Long value) {
            addCriterion("materiel_unit_id >=", value, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdLessThan(Long value) {
            addCriterion("materiel_unit_id <", value, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdLessThanOrEqualTo(Long value) {
            addCriterion("materiel_unit_id <=", value, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdIn(List<Long> values) {
            addCriterion("materiel_unit_id in", values, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdNotIn(List<Long> values) {
            addCriterion("materiel_unit_id not in", values, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdBetween(Long value1, Long value2) {
            addCriterion("materiel_unit_id between", value1, value2, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitIdNotBetween(Long value1, Long value2) {
            addCriterion("materiel_unit_id not between", value1, value2, "materielUnitId");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeIsNull() {
            addCriterion("materiel_unit_code is null");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeIsNotNull() {
            addCriterion("materiel_unit_code is not null");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeEqualTo(String value) {
            addCriterion("materiel_unit_code =", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeNotEqualTo(String value) {
            addCriterion("materiel_unit_code <>", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeGreaterThan(String value) {
            addCriterion("materiel_unit_code >", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeGreaterThanOrEqualTo(String value) {
            addCriterion("materiel_unit_code >=", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeLessThan(String value) {
            addCriterion("materiel_unit_code <", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeLessThanOrEqualTo(String value) {
            addCriterion("materiel_unit_code <=", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeLike(String value) {
            addCriterion("materiel_unit_code like", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeNotLike(String value) {
            addCriterion("materiel_unit_code not like", value, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeIn(List<String> values) {
            addCriterion("materiel_unit_code in", values, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeNotIn(List<String> values) {
            addCriterion("materiel_unit_code not in", values, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeBetween(String value1, String value2) {
            addCriterion("materiel_unit_code between", value1, value2, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitCodeNotBetween(String value1, String value2) {
            addCriterion("materiel_unit_code not between", value1, value2, "materielUnitCode");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameIsNull() {
            addCriterion("materiel_unit_name is null");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameIsNotNull() {
            addCriterion("materiel_unit_name is not null");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameEqualTo(String value) {
            addCriterion("materiel_unit_name =", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameNotEqualTo(String value) {
            addCriterion("materiel_unit_name <>", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameGreaterThan(String value) {
            addCriterion("materiel_unit_name >", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameGreaterThanOrEqualTo(String value) {
            addCriterion("materiel_unit_name >=", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameLessThan(String value) {
            addCriterion("materiel_unit_name <", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameLessThanOrEqualTo(String value) {
            addCriterion("materiel_unit_name <=", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameLike(String value) {
            addCriterion("materiel_unit_name like", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameNotLike(String value) {
            addCriterion("materiel_unit_name not like", value, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameIn(List<String> values) {
            addCriterion("materiel_unit_name in", values, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameNotIn(List<String> values) {
            addCriterion("materiel_unit_name not in", values, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameBetween(String value1, String value2) {
            addCriterion("materiel_unit_name between", value1, value2, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andMaterielUnitNameNotBetween(String value1, String value2) {
            addCriterion("materiel_unit_name not between", value1, value2, "materielUnitName");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesIsNull() {
            addCriterion("car_optional_packages is null");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesIsNotNull() {
            addCriterion("car_optional_packages is not null");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesEqualTo(String value) {
            addCriterion("car_optional_packages =", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesNotEqualTo(String value) {
            addCriterion("car_optional_packages <>", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesGreaterThan(String value) {
            addCriterion("car_optional_packages >", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesGreaterThanOrEqualTo(String value) {
            addCriterion("car_optional_packages >=", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesLessThan(String value) {
            addCriterion("car_optional_packages <", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesLessThanOrEqualTo(String value) {
            addCriterion("car_optional_packages <=", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesLike(String value) {
            addCriterion("car_optional_packages like", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesNotLike(String value) {
            addCriterion("car_optional_packages not like", value, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesIn(List<String> values) {
            addCriterion("car_optional_packages in", values, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesNotIn(List<String> values) {
            addCriterion("car_optional_packages not in", values, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesBetween(String value1, String value2) {
            addCriterion("car_optional_packages between", value1, value2, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andCarOptionalPackagesNotBetween(String value1, String value2) {
            addCriterion("car_optional_packages not between", value1, value2, "carOptionalPackages");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Integer value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Integer value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Integer value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Integer value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Integer value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Integer value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Integer> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Integer> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Integer value1, Integer value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Integer value1, Integer value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("is_delete is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("is_delete is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(Boolean value) {
            addCriterion("is_delete =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(Boolean value) {
            addCriterion("is_delete <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(Boolean value) {
            addCriterion("is_delete >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_delete >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(Boolean value) {
            addCriterion("is_delete <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(Boolean value) {
            addCriterion("is_delete <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<Boolean> values) {
            addCriterion("is_delete in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<Boolean> values) {
            addCriterion("is_delete not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(Boolean value1, Boolean value2) {
            addCriterion("is_delete between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_delete not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNull() {
            addCriterion("created_by is null");
            return (Criteria) this;
        }

        public Criteria andCreatedByIsNotNull() {
            addCriterion("created_by is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedByEqualTo(Long value) {
            addCriterion("created_by =", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotEqualTo(Long value) {
            addCriterion("created_by <>", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThan(Long value) {
            addCriterion("created_by >", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByGreaterThanOrEqualTo(Long value) {
            addCriterion("created_by >=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThan(Long value) {
            addCriterion("created_by <", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByLessThanOrEqualTo(Long value) {
            addCriterion("created_by <=", value, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByIn(List<Long> values) {
            addCriterion("created_by in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotIn(List<Long> values) {
            addCriterion("created_by not in", values, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByBetween(Long value1, Long value2) {
            addCriterion("created_by between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedByNotBetween(Long value1, Long value2) {
            addCriterion("created_by not between", value1, value2, "createdBy");
            return (Criteria) this;
        }

        public Criteria andCreatedOnIsNull() {
            addCriterion("created_on is null");
            return (Criteria) this;
        }

        public Criteria andCreatedOnIsNotNull() {
            addCriterion("created_on is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedOnEqualTo(Date value) {
            addCriterion("created_on =", value, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnNotEqualTo(Date value) {
            addCriterion("created_on <>", value, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnGreaterThan(Date value) {
            addCriterion("created_on >", value, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnGreaterThanOrEqualTo(Date value) {
            addCriterion("created_on >=", value, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnLessThan(Date value) {
            addCriterion("created_on <", value, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnLessThanOrEqualTo(Date value) {
            addCriterion("created_on <=", value, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnIn(List<Date> values) {
            addCriterion("created_on in", values, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnNotIn(List<Date> values) {
            addCriterion("created_on not in", values, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnBetween(Date value1, Date value2) {
            addCriterion("created_on between", value1, value2, "createdOn");
            return (Criteria) this;
        }

        public Criteria andCreatedOnNotBetween(Date value1, Date value2) {
            addCriterion("created_on not between", value1, value2, "createdOn");
            return (Criteria) this;
        }

        public Criteria andModifiedByIsNull() {
            addCriterion("modified_by is null");
            return (Criteria) this;
        }

        public Criteria andModifiedByIsNotNull() {
            addCriterion("modified_by is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedByEqualTo(Long value) {
            addCriterion("modified_by =", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotEqualTo(Long value) {
            addCriterion("modified_by <>", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByGreaterThan(Long value) {
            addCriterion("modified_by >", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByGreaterThanOrEqualTo(Long value) {
            addCriterion("modified_by >=", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByLessThan(Long value) {
            addCriterion("modified_by <", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByLessThanOrEqualTo(Long value) {
            addCriterion("modified_by <=", value, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByIn(List<Long> values) {
            addCriterion("modified_by in", values, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotIn(List<Long> values) {
            addCriterion("modified_by not in", values, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByBetween(Long value1, Long value2) {
            addCriterion("modified_by between", value1, value2, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedByNotBetween(Long value1, Long value2) {
            addCriterion("modified_by not between", value1, value2, "modifiedBy");
            return (Criteria) this;
        }

        public Criteria andModifiedOnIsNull() {
            addCriterion("modified_on is null");
            return (Criteria) this;
        }

        public Criteria andModifiedOnIsNotNull() {
            addCriterion("modified_on is not null");
            return (Criteria) this;
        }

        public Criteria andModifiedOnEqualTo(Date value) {
            addCriterion("modified_on =", value, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnNotEqualTo(Date value) {
            addCriterion("modified_on <>", value, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnGreaterThan(Date value) {
            addCriterion("modified_on >", value, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnGreaterThanOrEqualTo(Date value) {
            addCriterion("modified_on >=", value, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnLessThan(Date value) {
            addCriterion("modified_on <", value, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnLessThanOrEqualTo(Date value) {
            addCriterion("modified_on <=", value, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnIn(List<Date> values) {
            addCriterion("modified_on in", values, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnNotIn(List<Date> values) {
            addCriterion("modified_on not in", values, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnBetween(Date value1, Date value2) {
            addCriterion("modified_on between", value1, value2, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andModifiedOnNotBetween(Date value1, Date value2) {
            addCriterion("modified_on not between", value1, value2, "modifiedOn");
            return (Criteria) this;
        }

        public Criteria andEngineDescIsNull() {
            addCriterion("engine_desc is null");
            return (Criteria) this;
        }

        public Criteria andEngineDescIsNotNull() {
            addCriterion("engine_desc is not null");
            return (Criteria) this;
        }

        public Criteria andEngineDescEqualTo(String value) {
            addCriterion("engine_desc =", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescNotEqualTo(String value) {
            addCriterion("engine_desc <>", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescGreaterThan(String value) {
            addCriterion("engine_desc >", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescGreaterThanOrEqualTo(String value) {
            addCriterion("engine_desc >=", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescLessThan(String value) {
            addCriterion("engine_desc <", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescLessThanOrEqualTo(String value) {
            addCriterion("engine_desc <=", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescLike(String value) {
            addCriterion("engine_desc like", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescNotLike(String value) {
            addCriterion("engine_desc not like", value, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescIn(List<String> values) {
            addCriterion("engine_desc in", values, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescNotIn(List<String> values) {
            addCriterion("engine_desc not in", values, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescBetween(String value1, String value2) {
            addCriterion("engine_desc between", value1, value2, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andEngineDescNotBetween(String value1, String value2) {
            addCriterion("engine_desc not between", value1, value2, "engineDesc");
            return (Criteria) this;
        }

        public Criteria andCommercialLineIsNull() {
            addCriterion("commercial_line is null");
            return (Criteria) this;
        }

        public Criteria andCommercialLineIsNotNull() {
            addCriterion("commercial_line is not null");
            return (Criteria) this;
        }

        public Criteria andCommercialLineEqualTo(String value) {
            addCriterion("commercial_line =", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineNotEqualTo(String value) {
            addCriterion("commercial_line <>", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineGreaterThan(String value) {
            addCriterion("commercial_line >", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineGreaterThanOrEqualTo(String value) {
            addCriterion("commercial_line >=", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineLessThan(String value) {
            addCriterion("commercial_line <", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineLessThanOrEqualTo(String value) {
            addCriterion("commercial_line <=", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineLike(String value) {
            addCriterion("commercial_line like", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineNotLike(String value) {
            addCriterion("commercial_line not like", value, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineIn(List<String> values) {
            addCriterion("commercial_line in", values, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineNotIn(List<String> values) {
            addCriterion("commercial_line not in", values, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineBetween(String value1, String value2) {
            addCriterion("commercial_line between", value1, value2, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andCommercialLineNotBetween(String value1, String value2) {
            addCriterion("commercial_line not between", value1, value2, "commercialLine");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(String value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(String value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(String value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(String value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLike(String value) {
            addCriterion("order_type like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotLike(String value) {
            addCriterion("order_type not like", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<String> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<String> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(String value1, String value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(String value1, String value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateIsNull() {
            addCriterion("estimated_delivery_date is null");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateIsNotNull() {
            addCriterion("estimated_delivery_date is not null");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateEqualTo(String value) {
            addCriterion("estimated_delivery_date =", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateNotEqualTo(String value) {
            addCriterion("estimated_delivery_date <>", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateGreaterThan(String value) {
            addCriterion("estimated_delivery_date >", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateGreaterThanOrEqualTo(String value) {
            addCriterion("estimated_delivery_date >=", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateLessThan(String value) {
            addCriterion("estimated_delivery_date <", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateLessThanOrEqualTo(String value) {
            addCriterion("estimated_delivery_date <=", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateLike(String value) {
            addCriterion("estimated_delivery_date like", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateNotLike(String value) {
            addCriterion("estimated_delivery_date not like", value, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateIn(List<String> values) {
            addCriterion("estimated_delivery_date in", values, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateNotIn(List<String> values) {
            addCriterion("estimated_delivery_date not in", values, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateBetween(String value1, String value2) {
            addCriterion("estimated_delivery_date between", value1, value2, "estimatedDeliveryDate");
            return (Criteria) this;
        }

        public Criteria andEstimatedDeliveryDateNotBetween(String value1, String value2) {
            addCriterion("estimated_delivery_date not between", value1, value2, "estimatedDeliveryDate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}